{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Application data","Lists","Costs & spend profile","APPLICATION DATA ERROR CHECK"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":95,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Application data","index":0,"n_rows":186,"n_cols":12,"rows_kept":186,"cut":false,"hidden":false,"merged":[[1,2,1,7],[178,1,178,4],[5,2,6,7],[151,2,151,3],[152,2,152,3],[153,2,153,3],[149,5,149,7],[146,4,146,7],[147,4,147,7],[142,4,142,7],[144,4,144,7],[145,4,145,7],[143,4,143,7],[10,5,10,7],[23,5,23,7],[12,2,12,4],[168,9,168,11],[163,1,163,7],[164,1,164,7],[154,2,154,7],[161,5,161,7],[156,2,156,3],[157,2,157,3],[158,2,158,3],[159,2,159,7],[14,2,14,4],[16,2,21,4],[23,3,23,4],[79,2,79,7],[81,2,81,7],[52,2,52,3],[52,4,52,5],[52,6,52,7],[85,2,85,7],[24,5,24,7],[50,5,50,7],[69,5,69,7],[77,5,77,7],[83,2,83,7],[53,2,53,7],[59,3,59,4],[59,6,59,7],[185,1,185,2],[185,3,185,4],[168,1,168,6],[165,1,165,7],[174,1,174,2],[174,3,174,4],[175,1,175,2],[175,3,175,4],[182,1,182,2],[182,3,182,4],[183,1,183,2],[183,3,183,4],[170,1,170,4],[88,5,88,7],[100,1,100,2],[108,1,108,3],[136,5,136,7],[121,9,121,11],[118,1,118,2],[102,1,102,3],[91,1,91,2],[92,1,92,2],[95,1,95,2],[96,1,96,2],[99,1,99,2],[105,1,105,3],[139,1,139,7],[120,5,120,7],[113,1,113,2],[114,1,114,2],[115,1,115,2],[116,1,116,2],[117,1,117,2],[138,1,138,7]]}
[]
[null,null,{"$f":"IF(Lists!L78=0,\"\",\"APPLICATION HAS ERRORS - PLEASE CORRECT BEFORE SUBMISSION\")","v":"APPLICATION HAS ERRORS - PLEASE CORRECT BEFORE SUBMISSION"}]
[]
[null,null,"Application for Newbuild Scheme Loan"]
[]
[null,null,"BEFORE COMPLETING PLEASE CLEAR THE APPLICATION BY CLICKING ON THE BUTTON BELOW"]
[]
[null,{"$f":"IF(Lists!L76>0,\"Please refer to APPLICATION DATA ERROR CHECK worksheet\",\"\")","v":"Please refer to APPLICATION DATA ERROR CHECK worksheet"}]
[null,{"$f":"IF(Lists!L77>0,\"Please refer to Costs & spend profile worksheet error check\",\"\")","v":""}]
[]
[null,"General information"]
[]
[null,"Approved Housing Body Name:",null,null,null,{"$f":"IF(C13=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[]
[null,"Name of Scheme:",null,null,null,{"$f":"IF(C15=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[]
[null,"Scheme Address:"]
[]
[null,null,null,null,null,{"$f":"IF(C17=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[]
[]
[]
[]
[]
[null,"SECTION 1 - CONSTRUCTION COST AND TIMING"]
[]
["a","Number of housing units (input as whole number only)",null,"çInput as number"]
[]
["b","Target start on site date: dd/mm/yyyy",null,{"$f":"IF(C29=0,\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
["c","Target completion date: dd/mm/yyyy",null,{"$f":"IF(C31=0,\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
["d","Construction cost breakdown as at: dd/mm/yyyy",null,{"$f":"IF(C33=0,\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
["e","Construction period (months) - input as number only",null,"çInput as number"]
[]
["f","Land/site valuation (OMV) from independent valuer",null,{"$f":"IF(C37=0,\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
["g","Completion valuation estimate (OMV) from independent valuer",null,{"$f":"IF(C39=0,\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
["h","Total construction cost excluding interest",null,{"$f":"IF(C41=0,\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
["i","Total contract retention",null,{"$f":"IF(C43=0,\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
["j","Total costs eligible for CALF",null,{"$f":"IF(C45=\"\",\"Check - please complete and insert number even if zero - do not leave blank\",\"\")","v":"Check - please complete and insert number even if zero - do not leave blank"}]
[]
["k","Retention eligible for CALF - select yes/no",null,"çSelect from drop down list"]
[]
["l","Total construction cost net of retention",{"$f":"C41-C43","v":0}]
[]
[null,"SECTION 2 - CALF & OTHER EQUITY"]
[]
["a","CALF status",null,null,null,null,null,null,{"$f":"IF(C53=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[null,"PAA approval status",null,null,null,null,null,null,{"$f":"IF(C54=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[]
["b","CALF % of eligible construction costs - enter number only",null,{"$f":"IF(C56=\"\",\"Check - please complete and insert number even if zero - do not leave blank\",\"\")","v":"Check - please complete and insert number even if zero - do not leave blank"}]
[]
["c","APPROVED CALF term in yrs (input as number only)",null,{"$f":"IF(C58=\"\",\"Check - please complete and insert number even if zero - do not leave blank\",\"\")","v":"Check - please complete and insert number even if zero - do not leave blank"}]
[]
["d","APPROVED CALF subsidy total - enter number only",null,{"$f":"IF(Lists!N25=TRUE,\"Cannot be zero where there are eligible costs - CHECK\",\"\")","v":""},null,{"$f":"IF(C56>0,C60/C45,0)","v":0},{"$f":"IF(F60=C56,\"\",\"Check CALF amount\")","v":""}]
[]
["f","Total construction cost net of CALF",{"$f":"C41-C60","v":0},{"$f":"IF(C62<0,\"ERROR-cannot be negative please check Cells C56 & C60\",\"\")","v":""}]
[]
["g","CALF on contract retention",{"$f":"ROUND((E64*C43),0)","v":0},null,{"$f":"IF(C47=\"Yes\",C56,0%)","v":0}]
[]
["i","Additional equity contribution or additional subsidy",null,{"$f":"IF(C66=\"\",\"Please enter a value even if zero\",\"\")","v":"Please enter a value even if zero"}]
[]
["k","Total construction cost net of CALF & equity",{"$f":"C62-C66","v":0}]
[]
[null,"SECTION 3 - LOAN FACILITY DETAILS"]
[]
["a","The amount of construction loan requested from the HFA ",null,"Period (Months)",{"$f":"C35","v":0},{"$f":"IF(C72=\"\",\"CHECK Enter Constr loan requested\",\"\")","v":"CHECK Enter Constr loan requested"}]
[null,null,null,null,null,{"$f":"IF(E72=0,\"CHECK Enter Constr loan period\",\"\")","v":"CHECK Enter Constr loan period"}]
["b","Amount of long-term loan at completion requested from the HFA",null,"Period (years)",null,"çInput as number",null,{"$f":"IF(C74=\"\",\"CHECK Enter LT loan requested\",\"\")","v":"CHECK Enter LT loan requested"}]
[null,null,null,null,null,{"$f":"IF(E74=0,\"CHECK Enter LT loan period\",\"\")","v":"CHECK Enter LT loan period"}]
[null,"Interest basis",null,"çSelect from drop down list"]
[]
[null,"SECTION 4 - PROJECT STATUS"]
[]
["a","Planning status",null,null,null,null,null,null,{"$f":"IF(C80=\"\",\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
["b","Site acquisition status",null,null,null,null,null,null,{"$f":"IF(C82=\"\",\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
["c","Construction contract status",null,null,null,null,null,null,{"$f":"IF(C84=\"\",\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
["d","Main contractor's name",null,null,null,null,null,null,{"$f":"IF(C86=\"\",\"Check - please complete\",\"\")","v":"Check - please complete"}]
[]
[null,null,"All the above sections must be completed"]
[null,{"$f":"IF(F89=\"Construction loan only\",\"DO NOT COMPLETE\",\"SECTION 5 - MANAGEMENT & MAINTENANCE DATA\")","v":"SECTION 5 - MANAGEMENT & MAINTENANCE DATA"}]
[]
[null,"Management costs"]
["a","Input management costs per unit - year 1 (enter as whole number only)",null,"Per unit :",null,{"$f":"IF(E92=\"\",\"ERROR - Cannot be zero\",\"\")","v":"ERROR - Cannot be zero"}]
[null,"Management costs total in year 1",null,"Total :",{"$f":"E92*C27","v":0}]
[]
[null,"Reactive and void maintenance costs"]
["b","Input reactive and voids maintenance costs per unit - year one (enter whole number only)",null,"Per unit :",null,{"$f":"IF(E96=\"\",\"ERROR - Cannot be zero\",\"\")","v":"ERROR - Cannot be zero"}]
[null,{"$f":"B95&\" total in year 1\"","v":"Reactive and void maintenance costs total in year 1"},null,"Total :",{"$f":"E96*C27","v":0}]
[]
[null,"Cyclical maintenance costs"]
["c","Input cyclical maintenance costs per unit  - year 1 (enter whole number only)",null,"Per unit :"]
[null,{"$f":"B99&\" total in year 1\"","v":"Cyclical maintenance costs total in year 1"},null,"Total :",{"$f":"E100*C27","v":0}]
[]
["d","Choose if cyclical maintenance costs are assumed to be incurred annually or at 5 yearly intervals",null,null,null,"çSelect from drop down list"]
[]
[null,"Life cycle costs"]
[null,null,null,null,null,"çSelect from drop down list"]
[]
[null,"Sinking Fund"]
["e","Sinking Fund as % of Differential Rent (enter number only)",null,null,null,{"$f":"IF(Lists!N39=TRUE,\"Enter Sinking fund % of Differential Rent\",\"\")","v":""}]
[]
[null,"Profile"]
[null,"Cash life cycle spend",null,"Per unit"]
[null,null,null,"Year","Expenditure"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,null,null,{"$f":"IF(E106=\"Profile\",\"Please ensure that profile is correct\",\"\")","v":""}]
[]
[null,"SECTION 6 - PAA, INCOME & EXPENDITURE INFORMATION"]
[]
[null,null,null,"Per unit type"]
[null,"Unit type description","No of units (housing only)","Mk Rent pm","PAA market rent discount","PAA % of market rent","PAA pm","PAA p.a.","Service Charge Income p.a.","Diff Rent pw","Other income p.a.","Service costs p.a."]
[null,null,null,null,null,{"$f":"100%-E126","v":1},{"$f":"D126*F126","v":0},{"$f":"G126*12","v":0}]
[null,null,null,null,null,{"$f":"100%-E127","v":1},{"$f":"D127*F127","v":0},{"$f":"G127*12","v":0}]
[null,null,null,null,null,1,0,0]
[null,null,null,null,null,1,0,0]
[null,null,null,null,null,1,0,0]
[null,null,null,null,null,1,0,0]
[null,null,null,null,null,1,0,0]
[null,null,null,null,null,1,0,0]
[null,null,{"$f":"SUM(C126:C133)","v":0},{"$f":"SUM(D126:D133)","v":0},{"$f":"SUM(E126:E133)","v":0},null,{"$f":"SUM(G126:G133)","v":0},{"$f":"SUM(H126:H133)","v":0},{"$f":"SUM(I126:I133)","v":0},{"$f":"SUM(J126:J133)","v":0},{"$f":"SUM(K126:K133)","v":0},0]
[null,null,{"$f":"IF(C134=C27,\"\",\"Must equal number in cell C25\")","v":""}]
[]
[null,"SECTION 7  - INFORMATION CHECKLIST"]
[]
[null,"When submitting your application please confirm in the boxes provide below that you have included the additional information required."]
[null,"All documents submitted should either be originals or copies certified by an authorised officer."]
[]
[null,null,"Submitted",null,"Comments on other information submitted"]
[null,"Evidence of level of Availability Payments, evidence of CALF subsidy approval\nDraft Payment and Availability Agreement or letter from local authority  with details of proposed Availability Payments",null,"çSelect from drop down list",null,null,null,null,{"$f":"IF(C143=\"No\",\"Please explain PAA & CALF status\",\"\")","v":""}]
[null,"Description of scheme included with application",null,"çSelect from drop down list",null,null,null,null,{"$f":"IF(C144=\"No\",\"Please explain why no scheme description included\",\"\")","v":""}]
[null,"Valuation report (OMV Basis) on site/land to be acquired",null,"çSelect from drop down list",null,null,null,null,{"$f":"IF(C145=\"No\",\"Please discuss with the HFA before submission\",\"\")","v":""}]
[null,"Valuation report (\"OMV\") on completed properties",null,"çSelect from drop down list",null,null,null,null,{"$f":"IF(C146=\"No\",\"Please discuss with the HFA before submission\",\"\")","v":""}]
[null,"Scheme cost breakdown completed",null,"çSelect from drop down list",null,null,null,null,{"$f":"IF(C147=\"No\",\"Please do not submit without completing the costs breakdown\",\"\")","v":""}]
[null,"Project spend profile completed and any errors corrected",null,"çSelect from drop down list",null,null,null,null,{"$f":"IF(C148=\"No\",\"Please do not submit without completing the spend profile or correcting errors\",\"\")","v":""}]
[]
[null,"SECTION 9 - CONTACT INFORMATION"]
[]
[null,"Primary contact person :",null,null,{"$f":"IF(C152=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[null,"Primary contact job title :",null,null,{"$f":"IF(C153=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[null,"Primary contact telephone number :",null,null,{"$f":"IF(C154=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[null,"Primary contact email address :",null,null,null,null,null,null,{"$f":"IF(C155=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[]
[null,"Secondary contact person :",null,null,{"$f":"IF(C157=\"\",\"Please complete or state N/A\",\"\")","v":"Please complete or state N/A"}]
[null,"Secondary contact job title :",null,null,{"$f":"IF(C158=\"\",\"Please complete or state N/A\",\"\")","v":"Please complete or state N/A"}]
[null,"Secondary contact telephone number :",null,null,"Please complete or state N/A"]
[null,"Secondary contact email address :",null,null,null,null,null,null,{"$f":"IF(C160=\"\",\"Please complete or state N/A\",\"\")","v":"Please complete or state N/A"}]
[]
[null,"SECTION 10 - DECLARATION"]
[]
[null,"I/we declare that the information in this application is accurate and complete in all material respects and that I/we am appropriately authorised by the Board to sign and apply for a newbuild/development facility from the HFA. I/we understand that completion of this application with deliberately or negligently inaccurate or misleading data or by unauthorised signatories will invalidate this application, any rights of the applicant, any document and any arrangement entered into as a result of this application. I/We confirm that the underlying transactions for the construction of the scheme units will be entered into on commercial arms-length terms and that none of the subject contractual arrangements will be with a party which is a “connected person” (within the meaning of s. 10 of the Taxes Consolidation Act, 1997) of an officer or employee of the applicant AHB."]
[]
[null,"NOTICE: Under the Credit Reporting Act 2013 lenders are required to provide personal and credit information for credit applications and credit agreements of €500 and above to the Central Credit Register. This information may be used by other lenders when making decisions on your credit applications and credit agreements."]
[]
[]
[null,"In submitting this application for a development/newbuild loan facility we confirm that the information contained within this application is materially  correct and accurate, and we also confirm that we are not aware of any known reasons that may preclude us from entering into a loan arrangement with the Housing Finance Agency plc.",null,null,null,null,null,"No","çSelect from drop down list",{"$f":"IF(H169=\"No\",\"Applications without an affirmative declaration will not be accepted\",\"\")","v":"Applications without an affirmative declaration will not be accepted"}]
[null,"Signature 1 "]
[null,null,null,null,null,"çSelect from drop down menu"]
[null,null,null,null,null,{"$f":"IF(B171=\"\",\"Please select from dop down menu\",\"\")","v":"Please select from dop down menu"}]
[]
[null,"Signature 1"]
[null,"Name :",null,null,null,{"$f":"IF(D175=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[null,"Job title :",null,null,null,{"$f":"IF(D176=\"\",\"Please complete\",\"\")","v":"Please complete"}]
[]
[null,"Signature 2"]
[null,null,null,null,null,"çSelect from drop down menu"]
[null,null,null,null,null,{"$f":"IF(B179=\"\",\"Please select from dop down menu\",\"\")","v":"Please select from dop down menu"}]
[]
[null,"Signature 2, if necessary"]
[null,"Name :",null,null,null,{"$f":"IF(D183=\"\",\"Please complete or state N/A\",\"\")","v":"Please complete or state N/A"}]
[null,"Job title :",null,null,null,{"$f":"IF(D184=\"\",\"Please complete or state N/A\",\"\")","v":"Please complete or state N/A"}]
[]
[null,"Application date : dd/mm/yyyy",null,null,null,{"$f":"IF(Lists!N74=FALSE,\"\",\"Please insert date\")","v":"Please insert date"}]

{"sheet":"Lists","index":1,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":true,"merged":[]}
[null,"Version: 20200325"]
[]
[null,"SinkingFund"]
[null,"Select",null,null,"Application data error checking"]
[null,"Cash"]
[null,"Reserve movement",null,null,"Approved Housing Body Name:",null,null,null,null,null,null,{"$f":"IF('Application data'!F13=\"\",0,1)","v":1}]
[null,null,null,null,"Name of Scheme:",null,null,null,null,null,null,{"$f":"IF('Application data'!F15=\"\",0,1)","v":1}]
[null,"TimePeriod",null,null,"Scheme Address:",null,null,null,null,null,null,{"$f":"IF('Application data'!F19=\"\",0,1)","v":1}]
[null,"Select",null,null,"Number of housing units (input as whole number)",null,null,null,null,null,null,{"$f":"IF('Application data'!C27=0,1,0)","v":1}]
[null,"Annual",null,null,"Target start on site date: dd/mm/yyyy",null,null,null,null,null,null,{"$f":"IF('Application data'!C29=0,1,0)","v":1}]
[null,"Five yearly",null,null,"Target completion date: dd/mm/yyyy",null,null,null,null,null,null,{"$f":"IF('Application data'!C31=0,1,0)","v":1}]
[null,null,null,null,"Construction cost breakdown as at: dd/mm/yyyy",null,null,null,null,null,null,{"$f":"IF('Application data'!C33=0,1,0)","v":1}]
[null,"YearsAdjustments",null,null,"Construction period (months) - input as number",null,null,null,null,null,null,{"$f":"IF('Application data'!C35=0,1,0)","v":1}]
[null,"Select",null,null,"Land/site valuation (OMV) from independent valuer",null,null,null,null,null,null,{"$f":"IF('Application data'!C37=0,1,0)","v":1}]
[null,3,null,null,"Completion valuation estimate (OMV) from independent valuer",null,null,null,null,null,null,{"$f":"IF('Application data'!C39=0,1,0)","v":1}]
[null,4,null,null,"Total construction cost excluding interest",null,null,null,null,null,null,{"$f":"IF('Application data'!C41=0,1,0)","v":1}]
[null,5,null,null,"Total contract retention",null,null,null,null,null,null,{"$f":"IF('Application data'!C43=0,1,0)","v":1}]
[null,null,null,null,"Total costs eligible for CALF",null,null,null,null,null,null,{"$f":"IF('Application data'!D45=\"\",0,1)","v":1}]
[null,"CALF eligible",null,null,"Retention eligible for CALF - select yes/no",null,null,null,null,null,null,{"$f":"IF('Application data'!C47=\"\",1,0)","v":1}]
[null,"Select",null,null,"CALF status",null,null,null,null,null,null,{"$f":"IF('Application data'!C53=\"\",1,0)","v":1}]
[null,"Yes",null,null,"PAA approval status",null,null,null,null,null,null,{"$f":"IF('Application data'!C54=\"\",1,0)","v":1}]
[null,"No",null,null,"CALF % of eligible construction costs - enter number",null,null,null,null,null,null,{"$f":"IF('Application data'!D56=\"\",0,1)","v":1}]
[null,null,null,null,"Approved CALF term in yrs (input as number)",null,null,null,null,null,null,{"$f":"IF('Application data'!C58=\"\",1,0)","v":1}]
[null,"Interest ",null,null,"CALF subsidy total - enter number",null,null,null,null,null,null,{"$f":"IF('Application data'!C60=\"\",1,0)","v":1}]
[null,"Select",null,null,"CALF subsidy total incorrect",null,null,null,null,null,null,{"$f":"IF(N25=FALSE,0,1)","v":0},null,{"$f":"AND('Application data'!C45>0,'Application data'!C60=0)","v":false}]
[null,"Paid",null,null,"Additional equity contribution/subsidy",null,null,null,null,null,null,{"$f":"IF('Application data'!C66=\"\",1,0)","v":1}]
[null,"Rolled-up",null,null,"The amount of construction loan requested from the HFA ",null,null,null,null,null,null,{"$f":"IF('Application data'!C72=\"\",1,0)","v":1}]
[null,null,null,null,"Amount of long-term loan at completion requested from the HFA",null,null,null,null,null,null,{"$f":"IF('Application data'!C74=\"\",1,0)","v":1}]
[null,"Facility type",null,null,"Period (years)",null,null,null,null,null,null,{"$f":"IF('Application data'!E74=\"\",1,0)","v":1}]
[null,"Select",null,null,"Interest basis",null,null,null,null,null,null,{"$f":"IF('Application data'!C76=\"\",1,0)","v":1}]
[null,"Construction loan only",null,null,"Planning status",null,null,null,null,null,null,{"$f":"IF('Application data'!C80=\"\",1,0)","v":1}]
[null,"Combined long-term facility",null,null,"Site acquisition status",null,null,null,null,null,null,{"$f":"IF('Application data'!C82=\"\",1,0)","v":1}]
[null,null,null,null,"Construction contract status",null,null,null,null,null,null,{"$f":"IF('Application data'!C84=\"\",1,0)","v":1}]
[null,"Yes/no 2",null,null,"Main contractor's name",null,null,null,null,null,null,{"$f":"IF('Application data'!C86=\"\",1,0)","v":1}]
[null,null,null,null,"Management costs",null,null,null,null,null,null,{"$f":"IF('Application data'!F92=\"ERROR - Cannot be zero\",1,0)","v":1}]
[null,"Yes",null,null,"Reactive and void maintenance costs",null,null,null,null,null,null,{"$f":"IF('Application data'!F96=\"ERROR - Cannot be zero\",1,0)","v":1}]
[null,"No",null,null,"Life Cyclical costs frequency selection",null,null,null,null,null,null,{"$f":"IF('Application data'!E103=\"\",1,0)","v":1}]
[null,"Not required",null,null,"Life cycle costs basis selection",null,null,null,null,null,null,{"$f":"IF('Application data'!E106=\"\",1,0)","v":1}]
[null,null,null,null,"Sinking fund % differential rent",null,null,null,null,null,null,{"$f":"IF(N39=TRUE,1,0)","v":0},null,{"$f":"AND('Application data'!E106=\"Sinking fund\",'Application data'!E109=0)","v":false}]
[null,"Life cycle costs",null,null,"Life cycle cost profile",null,null,null,null,null,null,{"$f":"IF(N40=FALSE,0,1)","v":0},null,{"$f":"AND('Application data'!E106=\"Profile\",SUM('Application data'!D114:E119)=0)","v":false}]
[null,"Select",null,null,"PAA, INCOME & EXPENDITURE INFORMATION"]
[null,"Sinking fund",null,null,"Number of housing units (input as whole number)",null,null,null,null,null,null,{"$f":"IF('Application data'!C134=0,1,0)","v":1}]
[null,"Profile",null,null,"Total units must match C25",null,null,null,null,null,null,{"$f":"IF('Application data'!C134='Application data'!C27,0,1)","v":0}]
[null,null,null,null,"Market rent per month",null,null,null,null,null,null,{"$f":"IF('Application data'!D134=0,1,0)","v":1}]
[null,"Interest basis",null,null,"Market rent discount",null,null,null,null,null,null,{"$f":"IF('Application data'!E134=0,1,0)","v":1}]
[null,"Select",null,null,"Differential rent per week",null,null,null,null,null,null,{"$f":"IF('Application data'!J134=0,1,0)","v":1}]
[null,"EIB eligible",null,null,"Information checklist"]
[null,"HFA fixed rate",null,null,"Evidence of PAA and/or CALF approval",null,null,null,null,null,null,{"$f":"IF('Application data'!C143=\"\",1,0)","v":1}]
[null,null,null,null,"Description of scheme",null,null,null,null,null,null,{"$f":"IF('Application data'!C144=\"\",1,0)","v":1}]
[null,"Signature 1",null,null,"Land/site OMV valuation",null,null,null,null,null,null,{"$f":"IF('Application data'!C145=\"\",1,0)","v":1}]
[null,"Signature 1 - Hard copy signed",null,null,"Completion OMV valuation",null,null,null,null,null,null,{"$f":"IF('Application data'!C146=\"\",1,0)","v":1}]
[null,"Signature 2 - Hard copy signed",null,null,"Scheme cost breakdown completed",null,null,null,null,null,null,{"$f":"IF('Application data'!C147=\"\",1,0)","v":1}]
[null,"Signature 2 not required",null,null,"Project spend profile completed",null,null,null,null,null,null,{"$f":"IF('Application data'!C148=\"\",1,0)","v":1}]
[null,null,null,null,"Contact information"]
[null,null,null,null,"Primary contact person :",null,null,null,null,null,null,{"$f":"IF('Application data'!C152=\"\",1,0)","v":1}]
[null,null,null,null,"Primary contact job title :",null,null,null,null,null,null,{"$f":"IF('Application data'!C153=\"\",1,0)","v":1}]
[null,null,null,null,"Primary contact telephone number :",null,null,null,null,null,null,{"$f":"IF('Application data'!C154=\"\",1,0)","v":1}]
[null,null,null,null,"Primary contact email address :",null,null,null,null,null,null,{"$f":"IF('Application data'!C155=\"\",1,0)","v":1}]
[null,null,null,null,"Secondary contact person :",null,null,null,null,null,null,{"$f":"IF('Application data'!E157=\"Please complete or state N/A\",1,0)","v":1}]
[null,null,null,null,"Secondary contact job title :",null,null,null,null,null,null,{"$f":"IF('Application data'!E158=\"Please complete or state N/A\",1,0)","v":1}]
[null,null,null,null,"Secondary contact telephone number :",null,null,null,null,null,null,{"$f":"IF('Application data'!E159=\"Please complete or state N/A\",1,0)","v":1}]
[null,null,null,null,"Secondary contact email address :",null,null,null,null,null,null,{"$f":"IF('Application data'!I160=\"Please complete or state N/A\",1,0)","v":1}]
[null,null,null,null,"Declaration"]
[null,null,null,null,"Affirmative declaration",null,null,null,null,null,null,{"$f":"IF(N64=FALSE,0,1)","v":1},null,{"$f":"OR('Application data'!H169=\"No\",'Application data'!H169=\"\")","v":true}]
[null,null,null,null,"Signature 1"]
[null,null,null,null,"Hard copy signature confirmed",null,null,null,null,null,null,{"$f":"IF('Application data'!B171=\"\",1,0)","v":1}]
[null,null,null,null,"Name :",null,null,null,null,null,null,{"$f":"IF('Application data'!D175=\"\",1,0)","v":1}]
[null,null,null,null,"Job title :",null,null,null,null,null,null,{"$f":"IF('Application data'!D176=\"\",1,0)","v":1}]
[null,null,null,null,"Signature 2"]
[null,null,null,null,"Hard copy signature confirmed or not needed",null,null,null,null,null,null,{"$f":"IF('Application data'!B179=\"\",1,0)","v":1}]
[null,null,null,null,"Name :",null,null,null,null,null,null,{"$f":"IF('Application data'!D183=\"\",1,0)","v":1}]
[null,null,null,null,"Job title :",null,null,null,null,null,null,{"$f":"IF('Application data'!D184=\"\",1,0)","v":1}]
[null,null,null,null,"Date"]
[null,null,null,null,"Date of application",null,null,null,null,null,null,{"$f":"IF(N74=FALSE,0,1)","v":1},null,{"$f":"OR('Application data'!D186=0,'Application data'!D186=\"\")","v":true}]
[]
[null,null,null,null,"Total errors - application data",null,null,null,null,null,null,{"$f":"SUM(L6:L74)","v":58}]
[null,null,null,null,"Total errors - costs & spend profile",null,null,null,null,null,null,{"$f":"'Costs & spend profile'!D76","v":0}]
[null,null,null,null,"Total errors - all",null,null,null,null,null,null,{"$f":"L77+L76","v":58}]

{"sheet":"Costs & spend profile","index":2,"n_rows":79,"n_cols":36,"rows_kept":79,"cut":false,"hidden":false,"merged":[[10,3,10,6],[11,3,11,6]]}
[]
[]
[]
[]
[]
[]
[]
["Application for Newbuild Scheme Loan - detailed cost breakdown & spend profile"]
[]
[]
[null,null,"Certified Borrower",{"$f":"'Application data'!C13","v":0}]
[null,null,"Project Name",{"$f":"'Application data'!C15","v":0}]
[null,null,"Number of Units",{"$f":"'Application data'!C27","v":0}]
[null,null,"Application date",{"$f":"'Application data'!D186","v":"00:00:00"}]
[null,null,"Cost breakdown as at (date)",{"$f":"'Application data'!C33","v":"00:00:00"}]
[null,null,"Project start date",{"$f":"'Application data'!C29","v":"00:00:00"}]
[null,null,"Project end date",{"$f":"'Application data'!C31","v":"00:00:00"},{"$f":"ROUND((((D17-D16)/365)*12),0)","v":0}]
[null,null,"Number of months from start on site to completion",{"$f":"'Application data'!C35","v":0}]
[]
[null,null,"Project cost detailed breakdown - please only input whole numbers",null,null,null,null,null,null,"Project spend profile - please only input whole numbers"]
[null,null,null,null,null,null,null,null,null,"NOTE:- Please do not enter post-completion retention or other post-completion payments in the spend profile."]
[null,null,null,null,"Approved CALF",null,null,null,null,null,null,"These items should be entered in cells L59 to L62"]
[null,null,null,null,"%","Total",null,null,null,null,null,null,{"$f":"SUM(AL24:AV24)","v":0}]
[null,null,null,null,{"$f":"'Application data'!C56","v":0},{"$f":"'Application data'!C60","v":0}]
[null,null,"Cost element","Amount","Eligible","Amount","Total net of CALF",null,null,null,null,{"$f":"SUM(M25:AJ25)","v":0},{"$f":"IF(M26=\"\",0,1)","v":0},{"$f":"IF(N26=\"\",0,1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Project month",{"$f":"IF(M43>0,1,\"\")","v":""},{"$f":"IF(N43>0,M26+1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"(select Yes/No)"]
[null,null,null,null,null,{"$f":"IF(E28=\"Yes\",ROUND((D28*$E$24),0),0)","v":0},{"$f":"D28-F28","v":0},null,null,{"$f":"IF(C28=\"\",\"\",C28)","v":""},null,{"$f":"SUM(M28:AJ28)","v":0}]
[null,null,null,null,null,{"$f":"IF(E29=\"Yes\",ROUND((D29*$E$24),0),0)","v":0},{"$f":"D29-F29","v":0},null,null,{"$f":"IF(C29=\"\",\"\",C29)","v":""},null,{"$f":"SUM(M29:AJ29)","v":0}]
[null,null,null,null,null,0,0,null,null,"",null,0]
[null,null,null,null,null,0,0,null,null,"",null,0]
[null,null,null,null,null,0,0,null,null,"",null,0]
[null,null,null,null,null,0,0,null,null,"",null,0]
[null,null,null,null,null,0,0,null,null,"",null,0]
[null,null,null,null,null,0,0,null,null,"",null,0]
[null,null,null,null,null,0,0,null,null,"",null,0]
[null,null,null,null,null,0,0,null,null,"",null,0]
[null,null,null,null,null,0,0,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,"Retention payment",null,{"$f":"SUM(M39:AJ39)","v":0}]
[]
[null,null,"Total retention",{"$f":"'Application data'!C43","v":0},{"$f":"'Application data'!C47","v":0},{"$f":"IF(E41=\"N0\",0,'Application data'!C64)","v":0},{"$f":"D41-F41","v":0},null,null,"Total retention",null,{"$f":"L40+L39","v":0},{"$f":"M39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Total project cost net of retention",{"$f":"D45-D41","v":0},null,{"$f":"F45-F41","v":0},{"$f":"G45-G41","v":0},null,null,"Total spend net of retention",null,{"$f":"SUM(M43:AJ43)","v":0},{"$f":"SUM(M28:M38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Total project cost",{"$f":"SUM(D28:D38)","v":0},null,{"$f":"SUM(F28:F38)","v":0},{"$f":"SUM(G28:G38)","v":0},null,null,"Total project spend",null,{"$f":"L41+L43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Additional equity/subsidy",{"$f":"-'Application data'!C66","v":0},null,null,null,null,null,"Additional equity/cash drawn down",null,{"$f":"SUM(M47:AJ47)","v":0}]
[null,null,"CALF drawn down - costs",{"$f":"F45-F41","v":0},null,null,null,null,null,"CALF drawn down - costs",null,{"$f":"SUM(M48:AJ48)","v":0}]
[null,null,"CALF drawn down - retention",{"$f":"F41","v":0},null,null,null,null,null,"CALF drawn down - retention",null,0]
[null,null,"Total CALF & additional funding",{"$f":"SUM(D47:D49)","v":0},null,null,null,null,null,"Total CALF & additional funding",null,{"$f":"SUM(L47:L49)","v":0},{"$f":"SUM(M47:M49)","v":0},{"$f":"SUM(N47:N49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Net funding requierment",{"$f":"D45-D50","v":0},null,null,null,null,null,"Net project funding requirement",null,{"$f":"L45-L50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,"Error checks - all data input MUST be whole numbers",null,null,null,null,null,null,"Post completion retention & payments"]
[]
[null,null,"1. Project costs detail",null,null,null,null,null,null,"Post-completion retention payment (if applicable)",null,null,"◄ Post-completion retention payment gross of CALF"]
[null,null,"Total project cost equals application data",{"$f":"IF(D45='Application data'!C41,\"OK\",\"CHECK\")","v":"OK"},null,null,{"$f":"IF(D60=\"OK\",0,1)","v":0},null,null,"Post-completion expenditure (if any)",null,null,"◄ Other post-completion payments gross of CALF"]
[null,null,null,null,null,null,null,null,null,"Post-completion other costs CALF (if applicable)",null,null,"◄ CALF other post-completion payments (positive number)"]
[null,null,"Total retention equals application data",{"$f":"IF(D41='Application data'!C43,\"OK\",\"CHECK\")","v":"OK"},null,null,{"$f":"IF(D62=\"OK\",0,1)","v":0},null,null,"Post-completion retention CALF (if applicable)",null,null,"◄ Post completion retention CALF (poistive number)"]
[null,null,"Total spend net of retention equals application data",{"$f":"IF(D43='Application data'!C49,\"OK\",\"CHECK\")","v":"OK"},null,null,0,null,null,"Net post completion payments",null,{"$f":"L59+L60-L62","v":0}]
[null,null,"Total CALF equals application data",{"$f":"IF(D48+D49='Application data'!C60,\"OK\",\"CHECK\")","v":"OK"},null,null,0]
[null,null,"Additional equity/cash equals application data",{"$f":"IF(D47='Application data'!C66,\"OK\",\"CHECK\")","v":"OK"},null,null,0,null,null,"Reconciliation"]
[null,null,"Construction period in months matches application data",{"$f":"IF(L25='Application data'!C35,\"OK\",\"CHECK\")","v":"OK"},null,null,0]
[null,null,null,null,null,null,null,null,null,"Total project spend including retention",null,{"$f":"L45+L59+L60","v":0}]
[null,null,"2. Spend profile",null,null,null,null,null,null,"Total CALF including post completion receipts",null,{"$f":"L50+L61+L62","v":0}]
[null,null,"Total retention equals cost detail",{"$f":"IF(L69=D41,\"OK\",\"CHECK\")","v":"OK"},null,null,{"$f":"IF(D69=\"OK\",0,1)","v":0},null,null,"Total retention gross of CALF",null,{"$f":"L41+L59","v":0}]
[null,null,"Total spend net of retention equals cost detail",{"$f":"IF((L70+L59)=D45,\"OK\",\"CHECK\")","v":"OK"},null,null,0,null,null,"Total spend net of retention",null,{"$f":"L45+L60","v":0}]
[null,null,"Total project spend equals cost detail",{"$f":"IF(L67=D45,\"OK\",\"CHECK\")","v":"OK"},null,null,0,null,null,"Total project funding requirement",null,{"$f":"L45+L59+L60-L50-L62-L61","v":0}]
[null,null,"CALF + equity/cash equals cost detail",{"$f":"IF(L50+L62+L61=D50,\"OK\",\"CHECK\")","v":"OK"},null,null,0]
[null,null,"Total retention CALF equals cost detail",{"$f":"IF(L49+L62=D49,\"OK\",\"CHECK\")","v":"OK"},null,null,0]
[null,null,"Net project funding requirement equals cost detail",{"$f":"IF(L71=D52,\"OK\",\"CHECK\")","v":"OK"},null,null,0]
[]
[null,null,"Total errors",{"$f":"SUM(G60:G74)","v":0}]
[]
[]
[null,null,{"$f":"IF(D76=0,\"\",\"Worksheet has errors - please do not submit until corrected. Please check that all input figures are whole numbers\")","v":""}]

{"sheet":"APPLICATION DATA ERROR CHECK","index":3,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"ERROR CHECK TOTAL"]
[null,null,{"$f":"Lists!L76","v":58}]
[]
[null,null,"Cell","Description","Check","Notes/corrective action"]
[null,null,"C13","Approved Housing Body Name",{"$f":"IF(Lists!L6=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E6=\"ERROR\",\"Enter AHB name\",\"\")","v":"Enter AHB name"}]
[null,null,"C15","Name of Scheme",{"$f":"IF(Lists!L7=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E7=\"ERROR\",\"Enter scheme/project name\",\"\")","v":"Enter scheme/project name"}]
[null,null,"C17","Scheme Address:",{"$f":"IF(Lists!L8=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E8=\"ERROR\",\"Enter scheme/project address\",\"\")","v":"Enter scheme/project address"}]
[null,null,"C27","Number of housing units",{"$f":"IF(Lists!L9=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E9=\"ERROR\",\"Enter total number of units for scheme/project as a whole number\",\"\")","v":"Enter total number of units for scheme/project as a whole number"}]
[null,null,"C29","Target start on site date",{"$f":"IF(Lists!L10=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E10=\"ERROR\",\"Enter start on sited date in format 01/mm/yyyy\",\"\")","v":"Enter start on sited date in format 01/mm/yyyy"}]
[null,null,"C31","Target completion date",{"$f":"IF(Lists!L11=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E11=\"ERROR\",\"Enter completion date in format 01/mm/yyyy\",\"\")","v":"Enter completion date in format 01/mm/yyyy"}]
[null,null,"C33","Construction cost breakdown date",{"$f":"IF(Lists!L12=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E12=\"ERROR\",\"Enter date of construction costs breakdown in format dd/mm/yyyy\",\"\")","v":"Enter date of construction costs breakdown in format dd/mm/yyyy"}]
[null,null,"C35","Construction period (months)",{"$f":"IF(Lists!L13=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E13=\"ERROR\",\"Enter construction period as a whole number of months\",\"\")","v":"Enter construction period as a whole number of months"}]
[null,null,"C37","Land/site valuation (OMV) from independent valuer",{"$f":"IF(Lists!L14=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E14=\"ERROR\",\"Enter your valuer's site/land valuation as a whole number\",\"\")","v":"Enter your valuer's site/land valuation as a whole number"}]
[null,null,"C39","Completion valuation (OMV) from independent valuer",{"$f":"IF(Lists!L15=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E15=\"ERROR\",\"Enter your valuer's completed project valuation as a whole number\",\"\")","v":"Enter your valuer's completed project valuation as a whole number"}]
[null,null,"C41","Total construction cost excluding interest",{"$f":"IF(Lists!L16=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E16=\"ERROR\",\"Enter the total project/construction costs including site/land purchase as a whole number\",\"\")","v":"Enter the total project/construction costs including site/land purchase as a whole number"}]
[null,null,"C43","Total contract retention",{"$f":"IF(Lists!L17=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E17=\"ERROR\",\"Enter the total contract retention as a whole number\",\"\")","v":"Enter the total contract retention as a whole number"}]
[null,null,"C45","Total costs eligible for CALF",{"$f":"IF(Lists!L18=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E18=\"ERROR\",\"Enter the total construction cost approved as eligible for CALF as a whole number even if zero\",\"\")","v":"Enter the total construction cost approved as eligible for CALF as a whole number even if zero"}]
[null,null,"C47","Retention eligible for CALF - select yes/no",{"$f":"IF(Lists!L19=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E19=\"ERROR\",\"Select 'Yes' or 'No' from the drop down in cell C47\",\"\")","v":"Select 'Yes' or 'No' from the drop down in cell C47"}]
[null,null,"C53","CALF approval status",{"$f":"IF(Lists!L20=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E20=\"ERROR\",\"Enter approval status (conditional, awaiting approval etc) - do not leave blank\",\"\")","v":"Enter approval status (conditional, awaiting approval etc) - do not leave blank"}]
[null,null,"C54","PAA approval status",{"$f":"IF(Lists!L21=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E21=\"ERROR\",\"Enter approval status (conditional, awaiting approval etc) - do not leave blank\",\"\")","v":"Enter approval status (conditional, awaiting approval etc) - do not leave blank"}]
[null,null,"C56","Approved CALF % of eligible costs",{"$f":"IF(Lists!L22=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E22=\"ERROR\",\"Enter CALF approved % of eligible costs as a whole number even if zero (automatically formats to %) - do not leave blank\",\"\")","v":"Enter CALF approved % of eligible costs as a whole number even if zero (automatically formats to %) - do not leave blank"}]
[null,null,"C58","Approved CALF term",{"$f":"IF(Lists!L23=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E23=\"ERROR\",\"Enter CALF approved term as a whole number even if zero (automatically formats to 'Years') - do not leave blank\",\"\")","v":"Enter CALF approved term as a whole number even if zero (automatically formats to 'Years') - do not leave blank"}]
[null,null,"C60","Total amount of approved CALF",{"$f":"IF(Lists!L24=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E24=\"ERROR\",\"Enter total approved CALF as a whole number (automatically formats to Euros) - do not leave blank\",\"\")","v":"Enter total approved CALF as a whole number (automatically formats to Euros) - do not leave blank"}]
[null,null,"C60","Incorrect CALF amount",{"$f":"IF(Lists!L25=1,\"ERROR\",\"OK\")","v":"OK"},{"$f":"IF(E25=\"ERROR\",\"Amount entered as total CALF is incorrect - check and correct (whole number only)\",\"\")","v":""}]
[null,null,"C66","Additional equity or capital contribution",{"$f":"IF(Lists!L26=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E26=\"ERROR\",\"Please enter an amount even if nil (whole number only)\",\"\")","v":"Please enter an amount even if nil (whole number only)"}]
[null,null,"C72","Amount of construction loan requested from the HFA",{"$f":"IF(Lists!L27=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E27=\"ERROR\",\"Enter the total construction loan requested from the HFA as a whole number\",\"\")","v":"Enter the total construction loan requested from the HFA as a whole number"}]
[null,null,"C74","Amount of long-term loan at completion requested from the HFA",{"$f":"IF(Lists!L28=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E28=\"ERROR\",\"Enter the total long-term loan at completion requested from the HFA as a whole number\",\"\")","v":"Enter the total long-term loan at completion requested from the HFA as a whole number"}]
[null,null,"E74","Long-term loan period in years",{"$f":"IF(Lists!L29=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E29=\"ERROR\",\"Enter the long-term loan period requested from the HFA as a whole number (automatically formats to 'Years')\",\"\")","v":"Enter the long-term loan period requested from the HFA as a whole number (automatically formats to 'Years')"}]
[null,null,"C76","Interest basis",{"$f":"IF(Lists!L30=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E30=\"ERROR\",\"Please select the interest basis from the drop down in Cell C76 - do not leave blank\",\"\")","v":"Please select the interest basis from the drop down in Cell C76 - do not leave blank"}]
[null,null,"C80","Planning status",{"$f":"IF(Lists!L31=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E31=\"ERROR\",\"Please enter planning status - do not leave blank\",\"\")","v":"Please enter planning status - do not leave blank"}]
[null,null,"C82","Site acquisition status",{"$f":"IF(Lists!L32=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E32=\"ERROR\",\"Please enter site acquisition status/date of acquisition - do not leave blank\",\"\")","v":"Please enter site acquisition status/date of acquisition - do not leave blank"}]
[null,null,"C84","Construction contract status",{"$f":"IF(Lists!L33=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E33=\"ERROR\",\"Please enter construction contract status - do not leave blank\",\"\")","v":"Please enter construction contract status - do not leave blank"}]
[null,null,"C86","Main contractor's name",{"$f":"IF(Lists!L34=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E34=\"ERROR\",\"Please enter main contractor's name - do not leave blank\",\"\")","v":"Please enter main contractor's name - do not leave blank"}]
[null,null,"E92","Management costs",{"$f":"IF(Lists!L35=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E35=\"ERROR\",\"Please enter management cost per unit p.a. - cannot be zero or blank\",\"\")","v":"Please enter management cost per unit p.a. - cannot be zero or blank"}]
[null,null,"E96","Reactive and void maintenance costs",{"$f":"IF(Lists!L36=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E36=\"ERROR\",\"Please enter reactive maintenance cost per unit p.a. - cannot be zero or blank\",\"\")","v":"Please enter reactive maintenance cost per unit p.a. - cannot be zero or blank"}]
[null,null,"E103","Life Cyclical costs frequency selection",{"$f":"IF(Lists!L37=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E37=\"ERROR\",\"Please select cyclical maintenance costs basis from the drop down in Cell E103 - cannot be zero or blank\",\"\")","v":"Please select cyclical maintenance costs basis from the drop down in Cell E103 - cannot be zero or blank"}]
[null,null,"E106","Life cycle costs basis selection",{"$f":"IF(Lists!L38=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E38=\"ERROR\",\"Please select life cycle costs basis (Profile or Sinking Fund) from the drop down in Cell E106 - cannot be zero or blank\",\"\")","v":"Please select life cycle costs basis (Profile or Sinking Fund) from the drop down in Cell E106 - cannot be zero or blank"}]
[null,null,"E109","Sinking fund life cycle costs % of Differential Rent",{"$f":"IF(Lists!L39=1,\"ERROR\",\"OK\")","v":"OK"},{"$f":"IF(E39=\"ERROR\",\"You have selected 'Sinking fund' in Cell E106 - enter the % of Differential rent for the Sinking fund\",\"\")","v":""}]
[null,null,"D114-E119","Life cycle cost profile",{"$f":"IF(Lists!L40=1,\"ERROR\",\"OK\")","v":"OK"},{"$f":"IF(E40=\"ERROR\",\"You have selected 'Profile' in Cell E106 - enter the life cycle costs profile\",\"\")","v":""}]
[null,null,"C126-C133","Number of housing units (input as whole number)",{"$f":"IF(Lists!L42=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E41=\"ERROR\",\"Please enter the number of housing units by type\",\"\")","v":"Please enter the number of housing units by type"}]
[null,null,"C126-C133","Total number of housing units",{"$f":"IF(Lists!L43=1,\"ERROR\",\"OK\")","v":"OK"},{"$f":"IF(E42=\"ERROR\",\"Total number of units does not match the number entered in Cell C25 - please correct\",\"\")","v":""}]
[null,null,"D126-D133","Market rent per month",{"$f":"IF(Lists!L44=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E43=\"ERROR\",\"Please enter the market rent per month by unit type\",\"\")","v":"Please enter the market rent per month by unit type"}]
[null,null,"E126-E133","Market rent discount",{"$f":"IF(Lists!L45=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E44=\"ERROR\",\"Please enter the market rent discount by unit type\",\"\")","v":"Please enter the market rent discount by unit type"}]
[null,null,"J126-E133","Differential rent per week",{"$f":"IF(Lists!L46=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E45=\"ERROR\",\"Please enter the Differential Rent per week by unit type\",\"\")","v":"Please enter the Differential Rent per week by unit type"}]
[null,null,"C143","Evidence of PAA and/or CALF approval",{"$f":"IF(Lists!L48=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E46=\"ERROR\",\"Please select from the drop down in Cell143 - do not leave blank\",\"\")","v":"Please select from the drop down in Cell143 - do not leave blank"}]
[null,null,"C144","Description of scheme",{"$f":"IF(Lists!L49=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E47=\"ERROR\",\"Please select from the drop down in Cell144 - do not leave blank\",\"\")","v":"Please select from the drop down in Cell144 - do not leave blank"}]
[null,null,"C145","Land/site OMV valuation",{"$f":"IF(Lists!L50=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E48=\"ERROR\",\"Please select from the drop down in Cell145 - do not leave blank\",\"\")","v":"Please select from the drop down in Cell145 - do not leave blank"}]
[null,null,"C146","Completion OMV valuation",{"$f":"IF(Lists!L51=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E49=\"ERROR\",\"Please select from the drop down in Cell146 - do not leave blank\",\"\")","v":"Please select from the drop down in Cell146 - do not leave blank"}]
[null,null,"C147","Scheme cost breakdown completed",{"$f":"IF(Lists!L52=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E50=\"ERROR\",\"Please select from the drop down in Cell147 - do not leave blank\",\"\")","v":"Please select from the drop down in Cell147 - do not leave blank"}]
[null,null,"C148","Project spend profile completed",{"$f":"IF(Lists!L53=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E51=\"ERROR\",\"Please select from the drop down in Cell147 to confirm that the project cash flow sheet has been completed - do not leave blank\",\"\")","v":"Please select from the drop down in Cell147 to confirm that the project cash flow sheet has been completed - do not leave blank"}]
[null,null,"C152","Primary contact person",{"$f":"IF(Lists!L55=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E52=\"ERROR\",\"Please complete - do not leave blank\",\"\")","v":"Please complete - do not leave blank"}]
[null,null,"C153","Primary contact job title",{"$f":"IF(Lists!L56=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E53=\"ERROR\",\"Please complete - do not leave blank\",\"\")","v":"Please complete - do not leave blank"}]
[null,null,"C154","Primary contact telephone number",{"$f":"IF(Lists!L57=1,\"ERROR\",\"OK\")","v":"ERROR"},"Please complete - do not leave blank"]
[null,null,"C155","Primary contact email address",{"$f":"IF(Lists!L58=1,\"ERROR\",\"OK\")","v":"ERROR"},"Please complete - do not leave blank"]
[null,null,"C157","Secondary contact person",{"$f":"IF(Lists!L59=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E56=\"ERROR\",\"Please complete or insert N/A (case sensitive) - do not leave blank\",\"\")","v":"Please complete or insert N/A (case sensitive) - do not leave blank"}]
[null,null,"C158","Secondary contact job title",{"$f":"IF(Lists!L60=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E57=\"ERROR\",\"Please complete or insert N/A (case sensitive) - do not leave blank\",\"\")","v":"Please complete or insert N/A (case sensitive) - do not leave blank"}]
[null,null,"C159","Secondary contact telephone number",{"$f":"IF(Lists!L61=1,\"ERROR\",\"OK\")","v":"ERROR"},"Please complete or insert N/A (case sensitive) - do not leave blank"]
[null,null,"C160","Secondary contact email address",{"$f":"IF(Lists!L62=1,\"ERROR\",\"OK\")","v":"ERROR"},"Please complete or insert N/A (case sensitive) - do not leave blank"]
[null,null,"H169","Declaration",{"$f":"IF(Lists!L64=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E60=\"ERROR\",\"Please select from the drop down in Cell H169 - DO NOT SUBMIT IF THE SELECTION IS 'NO'\",\"\")","v":"Please select from the drop down in Cell H169 - DO NOT SUBMIT IF THE SELECTION IS 'NO'"}]
[null,null,"B171","Signature 1",{"$f":"IF(Lists!L66=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E61=\"ERROR\",\"Please select from the drop down in Cell B171 to confirm hard copy signature - do not leave blank'\",\"\")","v":"Please select from the drop down in Cell B171 to confirm hard copy signature - do not leave blank'"}]
[null,null,"D175","Signature 1 Name",{"$f":"IF(Lists!L67=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E62=\"ERROR\",\"Please complete - do not leave blank'\",\"\")","v":"Please complete - do not leave blank'"}]
[null,null,"D176","Signature 1 Title",{"$f":"IF(Lists!L68=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E63=\"ERROR\",\"Please complete - do not leave blank'\",\"\")","v":"Please complete - do not leave blank'"}]
[null,null,"B179","Signature 2",{"$f":"IF(Lists!L70=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E64=\"ERROR\",\"Please select from the drop down in Cell B179 to confirm hard copy signature or N/A - do not leave blank'\",\"\")","v":"Please select from the drop down in Cell B179 to confirm hard copy signature or N/A - do not leave blank'"}]
[null,null,"D183","Signature 1 Name",{"$f":"IF(Lists!L71=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E65=\"ERROR\",\"Please complete or enter N/A (case sensitive) - do not leave blank'\",\"\")","v":"Please complete or enter N/A (case sensitive) - do not leave blank'"}]
[null,null,"D184","Signature 1 Title",{"$f":"IF(Lists!L72=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E66=\"ERROR\",\"Please complete or enter N/A (case sensitive) - do not leave blank'\",\"\")","v":"Please complete or enter N/A (case sensitive) - do not leave blank'"}]
[null,null,"D186","Application date",{"$f":"IF(Lists!L74=1,\"ERROR\",\"OK\")","v":"ERROR"},{"$f":"IF(E67=\"ERROR\",\"Please complete - do not leave blank'\",\"\")","v":"Please complete - do not leave blank'"}]